package com.xihu.credit.mapper;

import com.xihu.credit.entity.UserAuth;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserAuthMapper {

    @Insert("INSERT INTO user_auth (" +
            "user_id, full_name, id_number, gender, married, education, job_type, " +
            "has_social_security, annual_income, property_count, has_car, match_residence, " +
            "city_area, address, address_detail, longitude, latitude" +
            ") VALUES (" +
            "#{userId}, #{fullName}, #{idNumber}, #{gender}, #{married}, #{education}, #{jobType}, " +
            "#{hasSocialSecurity}, #{annualIncome}, #{propertyCount}, #{hasCar}, #{matchResidence}, " +
            "#{cityArea}, #{address}, #{addressDetail}, #{longitude}, #{latitude}" +
            ")")
    int insertUserAuth(UserAuth userAuth);
}
